Pandas Profiling Report

Dataset statistics

Number of variables	30
Number of observations	564211
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	36878
Duplicate rows (%)	6.5%
Total size in memory	129.1 MiB
Average record size in memory	240.0 B

Variable types

Numeric	20
Categorical	10

Alerts

Dataset has 36878 (6.5%) duplicate rows	Duplicates
`first_browser` has a high cardinality: 52 distinct values	High cardinality
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_booking`	High correlation
`days_from_account_created_until_booking` is highly correlated with `days_from_first_active_until_booking`	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `weekofyear_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_first_booking` and 1 other fields	High correlation
`dayofweek_first_active` is highly correlated with `dayofweek_first_booking` and 1 other fields	High correlation
`weekofyear_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_first_booking` is highly correlated with `day_first_active` and 1 other fields	High correlation
`dayofweek_first_booking` is highly correlated with `dayofweek_first_active` and 1 other fields	High correlation
`weekofyear_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_first_account_created` is highly correlated with `day_first_active` and 1 other fields	High correlation
`dayofweek_first_account_created` is highly correlated with `dayofweek_first_active` and 1 other fields	High correlation
`weekofyear_first_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_booking`	High correlation
`days_from_account_created_until_booking` is highly correlated with `days_from_first_active_until_booking`	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `weekofyear_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_first_booking` and 1 other fields	High correlation
`dayofweek_first_active` is highly correlated with `dayofweek_first_booking` and 1 other fields	High correlation
`weekofyear_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_first_booking` is highly correlated with `day_first_active` and 1 other fields	High correlation
`dayofweek_first_booking` is highly correlated with `dayofweek_first_active` and 1 other fields	High correlation
`weekofyear_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_first_account_created` is highly correlated with `day_first_active` and 1 other fields	High correlation
`dayofweek_first_account_created` is highly correlated with `dayofweek_first_active` and 1 other fields	High correlation
`weekofyear_first_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_booking`	High correlation
`days_from_account_created_until_booking` is highly correlated with `days_from_first_active_until_booking`	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `weekofyear_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_first_booking` and 1 other fields	High correlation
`dayofweek_first_active` is highly correlated with `dayofweek_first_booking` and 1 other fields	High correlation
`weekofyear_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_first_booking` is highly correlated with `day_first_active` and 1 other fields	High correlation
`dayofweek_first_booking` is highly correlated with `dayofweek_first_active` and 1 other fields	High correlation
`weekofyear_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_first_account_created` is highly correlated with `day_first_active` and 1 other fields	High correlation
`dayofweek_first_account_created` is highly correlated with `dayofweek_first_active` and 1 other fields	High correlation
`weekofyear_first_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`signup_app` is highly correlated with `first_device_type`	High correlation
`first_device_type` is highly correlated with `signup_app` and 1 other fields	High correlation
`first_browser` is highly correlated with `first_device_type`	High correlation
`affiliate_channel` is highly correlated with `affiliate_provider`	High correlation
`affiliate_provider` is highly correlated with `affiliate_channel`	High correlation
`signup_flow` is highly correlated with `affiliate_channel` and 4 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_booking` and 4 other fields	High correlation
`days_from_account_created_until_booking` is highly correlated with `days_from_first_active_until_booking` and 4 other fields	High correlation
`year_first_active` is highly correlated with `days_from_first_active_until_booking` and 9 other fields	High correlation
`month_first_active` is highly correlated with `year_first_active` and 7 other fields	High correlation
`day_first_active` is highly correlated with `day_first_booking` and 1 other fields	High correlation
`dayofweek_first_active` is highly correlated with `dayofweek_first_booking` and 1 other fields	High correlation
`weekofyear_first_active` is highly correlated with `year_first_active` and 7 other fields	High correlation
`year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 9 other fields	High correlation
`month_first_booking` is highly correlated with `year_first_active` and 7 other fields	High correlation
`day_first_booking` is highly correlated with `day_first_active` and 1 other fields	High correlation
`dayofweek_first_booking` is highly correlated with `dayofweek_first_active` and 1 other fields	High correlation
`weekofyear_first_booking` is highly correlated with `year_first_active` and 7 other fields	High correlation
`year_first_account_created` is highly correlated with `days_from_first_active_until_booking` and 9 other fields	High correlation
`month_first_account_created` is highly correlated with `year_first_active` and 7 other fields	High correlation
`day_first_account_created` is highly correlated with `day_first_active` and 1 other fields	High correlation
`dayofweek_first_account_created` is highly correlated with `dayofweek_first_active` and 1 other fields	High correlation
`weekofyear_first_account_created` is highly correlated with `year_first_active` and 7 other fields	High correlation
`gender` is highly correlated with `age`	High correlation
`age` is highly correlated with `gender`	High correlation
`affiliate_channel` is highly correlated with `signup_flow` and 3 other fields	High correlation
`affiliate_provider` is highly correlated with `signup_flow` and 2 other fields	High correlation
`first_affiliate_tracked` is highly correlated with `affiliate_channel` and 1 other fields	High correlation
`signup_app` is highly correlated with `signup_flow` and 3 other fields	High correlation
`first_device_type` is highly correlated with `signup_flow` and 2 other fields	High correlation
`first_browser` is highly correlated with `signup_flow` and 2 other fields	High correlation
`country_destination` is highly correlated with `days_from_first_active_until_booking` and 1 other fields	High correlation
`days_from_first_active_until_account_created` is highly skewed (γ1 = 59.21177461)	Skewed
`signup_flow` has 452543 (80.2%) zeros	Zeros
`days_from_first_active_until_booking` has 98606 (17.5%) zeros	Zeros
`days_from_first_active_until_account_created` has 563497 (99.9%) zeros	Zeros
`days_from_account_created_until_booking` has 98583 (17.5%) zeros	Zeros
`dayofweek_first_active` has 89727 (15.9%) zeros	Zeros
`dayofweek_first_booking` has 89727 (15.9%) zeros	Zeros
`dayofweek_first_account_created` has 89727 (15.9%) zeros	Zeros

Reproduction

Analysis started	2022-05-16 20:32:04.219472
Analysis finished	2022-05-16 20:35:29.974449
Duration	3 minutes and 25.75 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

signup_flow
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.426328094

Minimum	0
Maximum	25
Zeros	452543
Zeros (%)	80.2%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	24
Maximum	25
Range	25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.591081925
Coefficient of variation (CV)	2.716484198
Kurtosis	6.445504223
Mean	2.426328094
Median Absolute Deviation (MAD)	0
Skewness	2.81998725
Sum	1368961
Variance	43.44236094
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	452543	80.2%
3	29387	5.2%
25	27560	4.9%
2	19425	3.4%
12	17682	3.1%
24	8491	1.5%
23	4616	0.8%
1	1591	0.3%
8	1296	0.2%
6	949	0.2%
Other values (7)	671	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	452543	80.2%
1	1591	0.3%
2	19425	3.4%
3	29387	5.2%
4	1	< 0.1%
5	31	< 0.1%
6	949	0.2%
8	1296	0.2%
10	2	< 0.1%
12	17682	3.1%

Value	Count	Frequency (%)
25	27560	4.9%
24	8491	1.5%
23	4616	0.8%
21	552	0.1%
20	14	< 0.1%
16	45	< 0.1%
15	26	< 0.1%
12	17682	3.1%
10	2	< 0.1%
8	1296	0.2%

days_from_first_active_until_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1940
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	181.5635108

Minimum	0
Maximum	2293
Zeros	98606
Zeros (%)	17.5%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	10
Q3	275
95-th percentile	874
Maximum	2293
Range	2293
Interquartile range (IQR)	274

Descriptive statistics

Standard deviation	305.0256055
Coefficient of variation (CV)	1.679993982
Kurtosis	3.568337832
Mean	181.5635108
Median Absolute Deviation (MAD)	10
Skewness	1.961718151
Sum	102440130
Variance	93040.62002
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	98606	17.5%
1	70367	12.5%
2	31157	5.5%
3	20444	3.6%
4	15669	2.8%
5	11772	2.1%
6	10244	1.8%
7	9008	1.6%
8	7345	1.3%
9	6603	1.2%
Other values (1930)	282996	50.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	98606	17.5%
1	70367	12.5%
2	31157	5.5%
3	20444	3.6%
4	15669	2.8%
5	11772	2.1%
6	10244	1.8%
7	9008	1.6%
8	7345	1.3%
9	6603	1.2%

Value	Count	Frequency (%)
2293	1	< 0.1%
2228	1	< 0.1%
2001	2	< 0.1%
1999	1	< 0.1%
1995	2	< 0.1%
1994	1	< 0.1%
1992	1	< 0.1%
1991	3	< 0.1%
1990	2	< 0.1%
1982	1	< 0.1%

days_from_first_active_until_account_created
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	142
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2856307303

Minimum	0
Maximum	1456
Zeros	563497
Zeros (%)	99.9%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1456
Range	1456
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.51771308
Coefficient of variation (CV)	43.82481206
Kurtosis	4152.152908
Mean	0.2856307303
Median Absolute Deviation (MAD)	0
Skewness	59.21177461
Sum	161156
Variance	156.6931407
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	563497	99.9%
5	69	< 0.1%
78	61	< 0.1%
274	50	< 0.1%
1	35	< 0.1%
3	35	< 0.1%
516	34	< 0.1%
634	34	< 0.1%
237	30	< 0.1%
6	24	< 0.1%
Other values (132)	342	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	563497	99.9%
1	35	< 0.1%
2	5	< 0.1%
3	35	< 0.1%
4	2	< 0.1%
5	69	< 0.1%
6	24	< 0.1%
7	6	< 0.1%
9	2	< 0.1%
10	7	< 0.1%

Value	Count	Frequency (%)
1456	1	< 0.1%
1369	1	< 0.1%
1361	1	< 0.1%
1148	1	< 0.1%
1036	1	< 0.1%
1018	1	< 0.1%
1011	22	< 0.1%
998	1	< 0.1%
995	1	< 0.1%
882	1	< 0.1%

days_from_account_created_until_booking
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1963
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	181.2778801

Minimum	-349
Maximum	2001
Zeros	98583
Zeros (%)	17.5%
Negative	220
Negative (%)	< 0.1%
Memory size	4.3 MiB

Quantile statistics

Minimum	-349
5-th percentile	0
Q1	1
median	10
Q3	274
95-th percentile	873
Maximum	2001
Range	2350
Interquartile range (IQR)	273

Descriptive statistics

Standard deviation	304.8293877
Coefficient of variation (CV)	1.681558652
Kurtosis	3.569870883
Mean	181.2778801
Median Absolute Deviation (MAD)	10
Skewness	1.961996198
Sum	102278974
Variance	92920.95563
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	98583	17.5%
1	70324	12.5%
2	31176	5.5%
3	20450	3.6%
4	15655	2.8%
5	11733	2.1%
6	10247	1.8%
7	9018	1.6%
8	7346	1.3%
9	6601	1.2%
Other values (1953)	283078	50.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-349	1	< 0.1%
-347	1	< 0.1%
-338	1	< 0.1%
-308	1	< 0.1%
-298	17	< 0.1%
-295	1	< 0.1%
-269	50	< 0.1%
-261	1	< 0.1%
-208	1	< 0.1%
-167	1	< 0.1%

Value	Count	Frequency (%)
2001	2	< 0.1%
1999	1	< 0.1%
1995	2	< 0.1%
1994	1	< 0.1%
1992	1	< 0.1%
1991	3	< 0.1%
1990	2	< 0.1%
1982	1	< 0.1%
1980	1	< 0.1%
1979	1	< 0.1%

year_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.984816

Minimum	2009
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	2009
5-th percentile	2011
Q1	2012
median	2013
Q3	2014
95-th percentile	2014
Maximum	2014
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.9420049634
Coefficient of variation (CV)	0.0004679642667
Kurtosis	0.03781470983
Mean	2012.984816
Median Absolute Deviation (MAD)	1
Skewness	-0.7333731123
Sum	1135748176
Variance	0.887373351
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	218473	38.7%
2014	192347	34.1%
2012	112103	19.9%
2011	35062	6.2%
2010	6217	1.1%
2009	9	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2009	9	< 0.1%
2010	6217	1.1%
2011	35062	6.2%
2012	112103	19.9%
2013	218473	38.7%
2014	192347	34.1%

Value	Count	Frequency (%)
2014	192347	34.1%
2013	218473	38.7%
2012	112103	19.9%
2011	35062	6.2%
2010	6217	1.1%
2009	9	< 0.1%

month_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.951323175

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.137649356
Coefficient of variation (CV)	0.527218782
Kurtosis	-0.8781805789
Mean	5.951323175
Median Absolute Deviation (MAD)	2
Skewness	0.2825451161
Sum	3357802
Variance	9.84484348
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	75865	13.4%
6	74972	13.3%
4	60024	10.6%
3	54246	9.6%
2	43414	7.7%
1	42308	7.5%
8	41167	7.3%
9	40653	7.2%
7	35863	6.4%
10	32731	5.8%
Other values (2)	62968	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	42308	7.5%
2	43414	7.7%
3	54246	9.6%
4	60024	10.6%
5	75865	13.4%
6	74972	13.3%
7	35863	6.4%
8	41167	7.3%
9	40653	7.2%
10	32731	5.8%

Value	Count	Frequency (%)
12	30463	5.4%
11	32505	5.8%
10	32731	5.8%
9	40653	7.2%
8	41167	7.3%
7	35863	6.4%
6	74972	13.3%
5	75865	13.4%
4	60024	10.6%
3	54246	9.6%

day_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.88474347

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.754571152
Coefficient of variation (CV)	0.5511307857
Kurtosis	-1.197873832
Mean	15.88474347
Median Absolute Deviation (MAD)	8
Skewness	-0.008580829205
Sum	8962347
Variance	76.64251605
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
28	20374	3.6%
24	19817	3.5%
3	19759	3.5%
13	19729	3.5%
17	19522	3.5%
16	19405	3.4%
5	19340	3.4%
23	19170	3.4%
10	18967	3.4%
21	18863	3.3%
Other values (21)	369265	65.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	15686	2.8%
2	17181	3.0%
3	19759	3.5%
4	17484	3.1%
5	19340	3.4%
6	18008	3.2%
7	18591	3.3%
8	18677	3.3%
9	18583	3.3%
10	18967	3.4%

Value	Count	Frequency (%)
31	9767	1.7%
30	18573	3.3%
29	16438	2.9%
28	20374	3.6%
27	18279	3.2%
26	18781	3.3%
25	18718	3.3%
24	19817	3.5%
23	19170	3.4%
22	18729	3.3%

dayofweek_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.772411385

Minimum	0
Maximum	6
Zeros	89727
Zeros (%)	15.9%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.967624831
Coefficient of variation (CV)	0.7097160405
Kurtosis	-1.177793694
Mean	2.772411385
Median Absolute Deviation (MAD)	2
Skewness	0.1633550305
Sum	1564225
Variance	3.871547475
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	90757	16.1%
2	89771	15.9%
0	89727	15.9%
3	84682	15.0%
4	74301	13.2%
6	67811	12.0%
5	67162	11.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	89727	15.9%
1	90757	16.1%
2	89771	15.9%
3	84682	15.0%
4	74301	13.2%
5	67162	11.9%
6	67811	12.0%

Value	Count	Frequency (%)
6	67811	12.0%
5	67162	11.9%
4	74301	13.2%
3	84682	15.0%
2	89771	15.9%
1	90757	16.1%
0	89727	15.9%

weekofyear_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.10089842

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	35
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	13.58975736
Coefficient of variation (CV)	0.5638693266
Kurtosis	-0.8683530105
Mean	24.10089842
Median Absolute Deviation (MAD)	10
Skewness	0.2848310216
Sum	13597992
Variance	184.6815052
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	18834	3.3%
23	17779	3.2%
19	17700	3.1%
21	17383	3.1%
25	16884	3.0%
24	16851	3.0%
22	16727	3.0%
20	16721	3.0%
18	16177	2.9%
17	14942	2.6%
Other values (43)	394213	69.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8253	1.5%
2	7863	1.4%
3	10277	1.8%
4	10802	1.9%
5	9977	1.8%
6	10508	1.9%
7	10443	1.9%
8	11567	2.1%
9	12161	2.2%
10	11835	2.1%

Value	Count	Frequency (%)
53	3	< 0.1%
52	6655	1.2%
51	6531	1.2%
50	6932	1.2%
49	7364	1.3%
48	6803	1.2%
47	7589	1.3%
46	8073	1.4%
45	7738	1.4%
44	7177	1.3%

year_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.984816

Minimum	2009
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	2009
5-th percentile	2011
Q1	2012
median	2013
Q3	2014
95-th percentile	2014
Maximum	2014
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.9420049634
Coefficient of variation (CV)	0.0004679642667
Kurtosis	0.03781470983
Mean	2012.984816
Median Absolute Deviation (MAD)	1
Skewness	-0.7333731123
Sum	1135748176
Variance	0.887373351
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	218473	38.7%
2014	192347	34.1%
2012	112103	19.9%
2011	35062	6.2%
2010	6217	1.1%
2009	9	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2009	9	< 0.1%
2010	6217	1.1%
2011	35062	6.2%
2012	112103	19.9%
2013	218473	38.7%
2014	192347	34.1%

Value	Count	Frequency (%)
2014	192347	34.1%
2013	218473	38.7%
2012	112103	19.9%
2011	35062	6.2%
2010	6217	1.1%
2009	9	< 0.1%

month_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.951323175

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.137649356
Coefficient of variation (CV)	0.527218782
Kurtosis	-0.8781805789
Mean	5.951323175
Median Absolute Deviation (MAD)	2
Skewness	0.2825451161
Sum	3357802
Variance	9.84484348
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	75865	13.4%
6	74972	13.3%
4	60024	10.6%
3	54246	9.6%
2	43414	7.7%
1	42308	7.5%
8	41167	7.3%
9	40653	7.2%
7	35863	6.4%
10	32731	5.8%
Other values (2)	62968	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	42308	7.5%
2	43414	7.7%
3	54246	9.6%
4	60024	10.6%
5	75865	13.4%
6	74972	13.3%
7	35863	6.4%
8	41167	7.3%
9	40653	7.2%
10	32731	5.8%

Value	Count	Frequency (%)
12	30463	5.4%
11	32505	5.8%
10	32731	5.8%
9	40653	7.2%
8	41167	7.3%
7	35863	6.4%
6	74972	13.3%
5	75865	13.4%
4	60024	10.6%
3	54246	9.6%

day_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.88474347

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.754571152
Coefficient of variation (CV)	0.5511307857
Kurtosis	-1.197873832
Mean	15.88474347
Median Absolute Deviation (MAD)	8
Skewness	-0.008580829205
Sum	8962347
Variance	76.64251605
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
28	20374	3.6%
24	19817	3.5%
3	19759	3.5%
13	19729	3.5%
17	19522	3.5%
16	19405	3.4%
5	19340	3.4%
23	19170	3.4%
10	18967	3.4%
21	18863	3.3%
Other values (21)	369265	65.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	15686	2.8%
2	17181	3.0%
3	19759	3.5%
4	17484	3.1%
5	19340	3.4%
6	18008	3.2%
7	18591	3.3%
8	18677	3.3%
9	18583	3.3%
10	18967	3.4%

Value	Count	Frequency (%)
31	9767	1.7%
30	18573	3.3%
29	16438	2.9%
28	20374	3.6%
27	18279	3.2%
26	18781	3.3%
25	18718	3.3%
24	19817	3.5%
23	19170	3.4%
22	18729	3.3%

dayofweek_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.772411385

Minimum	0
Maximum	6
Zeros	89727
Zeros (%)	15.9%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.967624831
Coefficient of variation (CV)	0.7097160405
Kurtosis	-1.177793694
Mean	2.772411385
Median Absolute Deviation (MAD)	2
Skewness	0.1633550305
Sum	1564225
Variance	3.871547475
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	90757	16.1%
2	89771	15.9%
0	89727	15.9%
3	84682	15.0%
4	74301	13.2%
6	67811	12.0%
5	67162	11.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	89727	15.9%
1	90757	16.1%
2	89771	15.9%
3	84682	15.0%
4	74301	13.2%
5	67162	11.9%
6	67811	12.0%

Value	Count	Frequency (%)
6	67811	12.0%
5	67162	11.9%
4	74301	13.2%
3	84682	15.0%
2	89771	15.9%
1	90757	16.1%
0	89727	15.9%

weekofyear_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.10089842

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	35
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	13.58975736
Coefficient of variation (CV)	0.5638693266
Kurtosis	-0.8683530105
Mean	24.10089842
Median Absolute Deviation (MAD)	10
Skewness	0.2848310216
Sum	13597992
Variance	184.6815052
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	18834	3.3%
23	17779	3.2%
19	17700	3.1%
21	17383	3.1%
25	16884	3.0%
24	16851	3.0%
22	16727	3.0%
20	16721	3.0%
18	16177	2.9%
17	14942	2.6%
Other values (43)	394213	69.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8253	1.5%
2	7863	1.4%
3	10277	1.8%
4	10802	1.9%
5	9977	1.8%
6	10508	1.9%
7	10443	1.9%
8	11567	2.1%
9	12161	2.2%
10	11835	2.1%

Value	Count	Frequency (%)
53	3	< 0.1%
52	6655	1.2%
51	6531	1.2%
50	6932	1.2%
49	7364	1.3%
48	6803	1.2%
47	7589	1.3%
46	8073	1.4%
45	7738	1.4%
44	7177	1.3%

year_first_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.984816

Minimum	2009
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	2009
5-th percentile	2011
Q1	2012
median	2013
Q3	2014
95-th percentile	2014
Maximum	2014
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.9420049634
Coefficient of variation (CV)	0.0004679642667
Kurtosis	0.03781470983
Mean	2012.984816
Median Absolute Deviation (MAD)	1
Skewness	-0.7333731123
Sum	1135748176
Variance	0.887373351
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	218473	38.7%
2014	192347	34.1%
2012	112103	19.9%
2011	35062	6.2%
2010	6217	1.1%
2009	9	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2009	9	< 0.1%
2010	6217	1.1%
2011	35062	6.2%
2012	112103	19.9%
2013	218473	38.7%
2014	192347	34.1%

Value	Count	Frequency (%)
2014	192347	34.1%
2013	218473	38.7%
2012	112103	19.9%
2011	35062	6.2%
2010	6217	1.1%
2009	9	< 0.1%

month_first_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.951323175

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.137649356
Coefficient of variation (CV)	0.527218782
Kurtosis	-0.8781805789
Mean	5.951323175
Median Absolute Deviation (MAD)	2
Skewness	0.2825451161
Sum	3357802
Variance	9.84484348
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	75865	13.4%
6	74972	13.3%
4	60024	10.6%
3	54246	9.6%
2	43414	7.7%
1	42308	7.5%
8	41167	7.3%
9	40653	7.2%
7	35863	6.4%
10	32731	5.8%
Other values (2)	62968	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	42308	7.5%
2	43414	7.7%
3	54246	9.6%
4	60024	10.6%
5	75865	13.4%
6	74972	13.3%
7	35863	6.4%
8	41167	7.3%
9	40653	7.2%
10	32731	5.8%

Value	Count	Frequency (%)
12	30463	5.4%
11	32505	5.8%
10	32731	5.8%
9	40653	7.2%
8	41167	7.3%
7	35863	6.4%
6	74972	13.3%
5	75865	13.4%
4	60024	10.6%
3	54246	9.6%

day_first_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.88474347

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.754571152
Coefficient of variation (CV)	0.5511307857
Kurtosis	-1.197873832
Mean	15.88474347
Median Absolute Deviation (MAD)	8
Skewness	-0.008580829205
Sum	8962347
Variance	76.64251605
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
28	20374	3.6%
24	19817	3.5%
3	19759	3.5%
13	19729	3.5%
17	19522	3.5%
16	19405	3.4%
5	19340	3.4%
23	19170	3.4%
10	18967	3.4%
21	18863	3.3%
Other values (21)	369265	65.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	15686	2.8%
2	17181	3.0%
3	19759	3.5%
4	17484	3.1%
5	19340	3.4%
6	18008	3.2%
7	18591	3.3%
8	18677	3.3%
9	18583	3.3%
10	18967	3.4%

Value	Count	Frequency (%)
31	9767	1.7%
30	18573	3.3%
29	16438	2.9%
28	20374	3.6%
27	18279	3.2%
26	18781	3.3%
25	18718	3.3%
24	19817	3.5%
23	19170	3.4%
22	18729	3.3%

dayofweek_first_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.772411385

Minimum	0
Maximum	6
Zeros	89727
Zeros (%)	15.9%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.967624831
Coefficient of variation (CV)	0.7097160405
Kurtosis	-1.177793694
Mean	2.772411385
Median Absolute Deviation (MAD)	2
Skewness	0.1633550305
Sum	1564225
Variance	3.871547475
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	90757	16.1%
2	89771	15.9%
0	89727	15.9%
3	84682	15.0%
4	74301	13.2%
6	67811	12.0%
5	67162	11.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	89727	15.9%
1	90757	16.1%
2	89771	15.9%
3	84682	15.0%
4	74301	13.2%
5	67162	11.9%
6	67811	12.0%

Value	Count	Frequency (%)
6	67811	12.0%
5	67162	11.9%
4	74301	13.2%
3	84682	15.0%
2	89771	15.9%
1	90757	16.1%
0	89727	15.9%

weekofyear_first_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.10089842

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	35
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	13.58975736
Coefficient of variation (CV)	0.5638693266
Kurtosis	-0.8683530105
Mean	24.10089842
Median Absolute Deviation (MAD)	10
Skewness	0.2848310216
Sum	13597992
Variance	184.6815052
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	18834	3.3%
23	17779	3.2%
19	17700	3.1%
21	17383	3.1%
25	16884	3.0%
24	16851	3.0%
22	16727	3.0%
20	16721	3.0%
18	16177	2.9%
17	14942	2.6%
Other values (43)	394213	69.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8253	1.5%
2	7863	1.4%
3	10277	1.8%
4	10802	1.9%
5	9977	1.8%
6	10508	1.9%
7	10443	1.9%
8	11567	2.1%
9	12161	2.2%
10	11835	2.1%

Value	Count	Frequency (%)
53	3	< 0.1%
52	6655	1.2%
51	6531	1.2%
50	6932	1.2%
49	7364	1.3%
48	6803	1.2%
47	7589	1.3%
46	8073	1.4%
45	7738	1.4%
44	7177	1.3%

gender
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

-unknown-	203055
FEMALE	190998
MALE	168896
OTHER	1262

Length

Max length	9
Median length	6
Mean length	6.478741109
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	-unknown-
2nd row	MALE
3rd row	FEMALE
4th row	FEMALE
5th row	-unknown-

Common Values

Value	Count	Frequency (%)
-unknown-	203055	36.0%
FEMALE	190998	33.9%
MALE	168896	29.9%
OTHER	1262	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
unknown	203055	36.0%
female	190998	33.9%
male	168896	29.9%
other	1262	0.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

age
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	99
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.85744518

Minimum	16
Maximum	115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	16
5-th percentile	24
Q1	31
median	40
Q3	49
95-th percentile	60
Maximum	115
Range	99
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	12.9449027
Coefficient of variation (CV)	0.3168309386
Kurtosis	4.407622748
Mean	40.85744518
Median Absolute Deviation (MAD)	9
Skewness	1.239106451
Sum	23052220
Variance	167.570506
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
49	169734	30.1%
30	20308	3.6%
31	19571	3.5%
32	19403	3.4%
29	19184	3.4%
28	17616	3.1%
33	17123	3.0%
27	16642	2.9%
34	16559	2.9%
35	14984	2.7%
Other values (89)	233087	41.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
16	26	< 0.1%
17	81	< 0.1%
18	2572	0.5%
19	4754	0.8%
20	1273	0.2%
21	3939	0.7%
22	6267	1.1%
23	8152	1.4%
24	10839	1.9%
25	14004	2.5%

Value	Count	Frequency (%)
115	12	< 0.1%
113	4	< 0.1%
112	1	< 0.1%
111	2	< 0.1%
110	357	0.1%
109	33	< 0.1%
108	15	< 0.1%
107	23	< 0.1%
106	28	< 0.1%
105	4417	0.8%

signup_method
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

basic	408915
facebook	154394
google	902

Length

Max length	8
Median length	5
Mean length	5.82253625
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	facebook
2nd row	facebook
3rd row	basic
4th row	facebook
5th row	basic

Common Values

Value	Count	Frequency (%)
basic	408915	72.5%
facebook	154394	27.4%
google	902	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
basic	408915	72.5%
facebook	154394	27.4%
google	902	0.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

language
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

en	548140
fr	3226
zh	2491
de	2409
es	2295
Other values (20)	5650

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	en
2nd row	en
3rd row	en
4th row	en
5th row	en

Common Values

Value	Count	Frequency (%)
en	548140	97.2%
fr	3226	0.6%
zh	2491	0.4%
de	2409	0.4%
es	2295	0.4%
ko	1384	0.2%
it	1128	0.2%
ru	737	0.1%
pt	495	0.1%
ja	432	0.1%
Other values (15)	1474	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
en	548140	97.2%
fr	3226	0.6%
zh	2491	0.4%
de	2409	0.4%
es	2295	0.4%
ko	1384	0.2%
it	1128	0.2%
ru	737	0.1%
pt	495	0.1%
ja	432	0.1%
Other values (15)	1474	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

affiliate_channel
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

direct	372131
sem-brand	73791
sem-non-brand	51928
seo	23817
other	17155
Other values (3)	25389

Length

Max length	13
Median length	6
Mean length	6.832964972
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	direct
2nd row	seo
3rd row	direct
4th row	direct
5th row	direct

Common Values

Value	Count	Frequency (%)
direct	372131	66.0%
sem-brand	73791	13.1%
sem-non-brand	51928	9.2%
seo	23817	4.2%
other	17155	3.0%
api	15797	2.8%
content	6716	1.2%
remarketing	2876	0.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
direct	372131	66.0%
sem-brand	73791	13.1%
sem-non-brand	51928	9.2%
seo	23817	4.2%
other	17155	3.0%
api	15797	2.8%
content	6716	1.2%
remarketing	2876	0.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

affiliate_provider
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

direct	371182
google	141935
other	24992
craigslist	6613
bing	6573
Other values (13)	12916

Length

Max length	19
Median length	6
Mean length	6.030770403
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	direct
2nd row	google
3rd row	direct
4th row	direct
5th row	direct

Common Values

Value	Count	Frequency (%)
direct	371182	65.8%
google	141935	25.2%
other	24992	4.4%
craigslist	6613	1.2%
bing	6573	1.2%
facebook	6250	1.1%
vast	1753	0.3%
facebook-open-graph	1286	0.2%
padmapper	1212	0.2%
yahoo	918	0.2%
Other values (8)	1497	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
direct	371182	65.8%
google	141935	25.2%
other	24992	4.4%
craigslist	6613	1.2%
bing	6573	1.2%
facebook	6250	1.1%
vast	1753	0.3%
facebook-open-graph	1286	0.2%
padmapper	1212	0.2%
yahoo	918	0.2%
Other values (8)	1497	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_affiliate_tracked
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

untracked	304407
linked	123296
omg	118337
tracked-other	12851
product	4961
Other values (2)	359

Length

Max length	13
Median length	9
Mean length	7.159504157
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	untracked
2nd row	untracked
3rd row	untracked
4th row	untracked
5th row	untracked

Common Values

Value	Count	Frequency (%)
untracked	304407	54.0%
linked	123296	21.9%
omg	118337	21.0%
tracked-other	12851	2.3%
product	4961	0.9%
marketing	231	< 0.1%
local ops	128	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
untracked	304407	53.9%
linked	123296	21.8%
omg	118337	21.0%
tracked-other	12851	2.3%
product	4961	0.9%
marketing	231	< 0.1%
local	128	< 0.1%
ops	128	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

signup_app
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Web	507444
iOS	36163
Moweb	11758
Android	8846

Length

Max length	7
Median length	3
Mean length	3.104393569
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Web
2nd row	Web
3rd row	Web
4th row	Web
5th row	Web

Common Values

Value	Count	Frequency (%)
Web	507444	89.9%
iOS	36163	6.4%
Moweb	11758	2.1%
Android	8846	1.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
web	507444	89.9%
ios	36163	6.4%
moweb	11758	2.1%
android	8846	1.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_device_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Mac Desktop	269616
Windows Desktop	194464
iPhone	41217
iPad	39371
Other/Unknown	8131
Other values (4)	11412

Length

Max length	18
Median length	11
Mean length	11.6132298
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mac Desktop
2nd row	Mac Desktop
3rd row	Windows Desktop
4th row	Mac Desktop
5th row	Mac Desktop

Common Values

Value	Count	Frequency (%)
Mac Desktop	269616	47.8%
Windows Desktop	194464	34.5%
iPhone	41217	7.3%
iPad	39371	7.0%
Other/Unknown	8131	1.4%
Android Phone	4551	0.8%
Desktop (Other)	3458	0.6%
Android Tablet	3300	0.6%
SmartPhone (Other)	103	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
desktop	467538	45.0%
mac	269616	25.9%
windows	194464	18.7%
iphone	41217	4.0%
ipad	39371	3.8%
other/unknown	8131	0.8%
android	7851	0.8%
phone	4551	0.4%
other	3561	0.3%
tablet	3300	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_browser
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Chrome	183051
Safari	132750
Firefox	98993
IE	53527
Mobile Safari	48171
Other values (47)	47719

Length

Max length	20
Median length	6
Mean length	6.683847001
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	Chrome
2nd row	Chrome
3rd row	IE
4th row	Firefox
5th row	Chrome

Common Values

Value	Count	Frequency (%)
Chrome	183051	32.4%
Safari	132750	23.5%
Firefox	98993	17.5%
IE	53527	9.5%
Mobile Safari	48171	8.5%
-unknown-	41219	7.3%
Chrome Mobile	2767	0.5%
Android Browser	1581	0.3%
Opera	438	0.1%
AOL Explorer	395	0.1%
Other values (42)	1319	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chrome	185818	30.1%
safari	180921	29.3%
firefox	99045	16.0%
ie	53563	8.7%
mobile	51028	8.3%
unknown	41219	6.7%
browser	1777	0.3%
android	1581	0.3%
opera	444	0.1%
explorer	440	0.1%
Other values (48)	1746	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

country_destination
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

NDF	119810
US	60800
other	49675
IT	41640
ES	39654
Other values (7)	252632

Length

Max length	5
Median length	2
Mean length	2.476479544
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NDF
2nd row	NDF
3rd row	US
4th row	other
5th row	US

Common Values

Value	Count	Frequency (%)
NDF	119810	21.2%
US	60800	10.8%
other	49675	8.8%
IT	41640	7.4%
ES	39654	7.0%
GB	38845	6.9%
CA	37395	6.6%
NL	37300	6.6%
AU	36820	6.5%
DE	36155	6.4%
Other values (2)	66117	11.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ndf	119810	21.2%
us	60800	10.8%
other	49675	8.8%
it	41640	7.4%
es	39654	7.0%
gb	38845	6.9%
ca	37395	6.6%
nl	37300	6.6%
au	36820	6.5%
de	36155	6.4%
Other values (2)	66117	11.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	signup_flow	days_from_first_active_until_booking	days_from_first_active_until_account_created	days_from_account_created_until_booking	year_first_active	month_first_active	day_first_active	dayofweek_first_active	weekofyear_first_active	year_first_booking	month_first_booking	day_first_booking	dayofweek_first_booking	weekofyear_first_booking	year_first_account_created	month_first_account_created	day_first_account_created	dayofweek_first_account_created	weekofyear_first_account_created	gender	age	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination
0	0	2293	466	1827	2009	3	19	3	12	2009	3	19	3	12	2009	3	19	3	12	-unknown-	49	facebook	en	direct	direct	untracked	Web	Mac Desktop	Chrome	NDF
1	0	2228	732	1496	2009	5	23	5	21	2009	5	23	5	21	2009	5	23	5	21	MALE	38	facebook	en	seo	google	untracked	Web	Mac Desktop	Chrome	NDF
2	3	419	476	-57	2009	6	9	1	24	2009	6	9	1	24	2009	6	9	1	24	FEMALE	56	basic	en	direct	direct	untracked	Web	Windows Desktop	IE	US
3	0	1043	765	278	2009	10	31	5	44	2009	10	31	5	44	2009	10	31	5	44	FEMALE	42	facebook	en	direct	direct	untracked	Web	Mac Desktop	Firefox	other
4	0	72	280	-208	2009	12	8	1	50	2009	12	8	1	50	2009	12	8	1	50	-unknown-	41	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	US
5	0	1	0	1	2010	1	1	4	53	2010	1	1	4	53	2010	1	1	4	53	-unknown-	49	basic	en	other	other	omg	Web	Mac Desktop	Chrome	US
6	0	3	0	3	2010	1	2	5	53	2010	1	2	5	53	2010	1	2	5	53	FEMALE	46	basic	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US
7	0	10	0	10	2010	1	3	6	53	2010	1	3	6	53	2010	1	3	6	53	FEMALE	47	basic	en	direct	direct	omg	Web	Mac Desktop	Safari	US
8	0	206	0	206	2010	1	4	0	1	2010	1	4	0	1	2010	1	4	0	1	FEMALE	50	basic	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US
9	0	0	0	0	2010	1	4	0	1	2010	1	4	0	1	2010	1	4	0	1	-unknown-	46	basic	en	other	craigslist	omg	Web	Mac Desktop	Firefox	US

Last rows

	days_from_first_active_until_booking	days_from_first_active_until_account_created	days_from_account_created_until_booking	year_first_active	month_first_active	day_first_active	dayofweek_first_active	weekofyear_first_active	year_first_booking	month_first_booking	day_first_booking	dayofweek_first_booking	weekofyear_first_booking	year_first_account_created	month_first_account_created	day_first_account_created	dayofweek_first_account_created	weekofyear_first_account_created	gender	age	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination
564201	25	0	25	2014	1	21	1	4	2014	1	21	1	4	2014	1	21	1	4	-unknown-	49	basic	en	direct	direct	untracked	Web	Mac Desktop	Safari	other
564202	2	0	2	2013	4	30	1	18	2013	4	30	1	18	2013	4	30	1	18	MALE	49	basic	ko	direct	direct	untracked	Web	Windows Desktop	Chrome	other
564203	338	0	338	2012	9	2	6	35	2012	9	2	6	35	2012	9	2	6	35	FEMALE	33	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	other
564204	4	0	4	2014	3	4	1	10	2014	3	4	1	10	2014	3	4	1	10	-unknown-	49	basic	fr	sem-brand	google	omg	Web	Mac Desktop	Chrome	other
564205	182	0	182	2014	6	21	5	25	2014	6	21	5	25	2014	6	21	5	25	MALE	43	basic	en	direct	direct	untracked	Web	Mac Desktop	Firefox	other
564206	26	0	26	2012	5	23	2	21	2012	5	23	2	21	2012	5	23	2	21	FEMALE	34	facebook	en	direct	direct	untracked	Web	Mac Desktop	Chrome	other
564207	1	0	1	2013	8	1	3	31	2013	8	1	3	31	2013	8	1	3	31	FEMALE	33	facebook	en	direct	direct	untracked	Web	Mac Desktop	Firefox	other
564208	0	0	0	2014	6	9	0	24	2014	6	9	0	24	2014	6	9	0	24	FEMALE	37	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	other
564209	0	0	0	2014	5	20	1	21	2014	5	20	1	21	2014	5	20	1	21	FEMALE	31	basic	en	direct	direct	untracked	Web	Mac Desktop	Safari	other
564210	158	10	148	2013	8	12	0	33	2013	8	12	0	33	2013	8	12	0	33	FEMALE	39	facebook	en	direct	direct	untracked	Web	Android Phone	Chrome Mobile	other

Most frequently occurring

	signup_flow	days_from_first_active_until_booking	days_from_account_created_until_booking	year_first_active	month_first_active	day_first_active	dayofweek_first_active	weekofyear_first_active	year_first_booking	month_first_booking	day_first_booking	dayofweek_first_booking	weekofyear_first_booking	year_first_account_created	month_first_account_created	day_first_account_created	dayofweek_first_account_created	weekofyear_first_account_created	gender	age	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination	# duplicates
15956	0	30	30	2013	12	27	4	52	2013	12	27	4	52	2013	12	27	4	52	MALE	30	basic	en	sem-brand	google	omg	Web	Mac Desktop	Firefox	PT	185
10883	0	4	4	2014	2	12	2	7	2014	2	12	2	7	2014	2	12	2	7	-unknown-	49	basic	en	seo	google	untracked	Web	Windows Desktop	Chrome	PT	182
2037	0	0	0	2013	9	17	1	38	2013	9	17	1	38	2013	9	17	1	38	FEMALE	28	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	PT	176
31383	3	0	0	2011	8	21	6	33	2011	8	21	6	33	2011	8	21	6	33	MALE	67	basic	en	direct	direct	untracked	Web	Windows Desktop	Firefox	PT	176
4260	0	0	0	2014	6	15	6	24	2014	6	15	6	24	2014	6	15	6	24	-unknown-	33	basic	en	sem-brand	google	untracked	Web	Windows Desktop	Chrome	PT	174
10647	0	4	4	2013	5	14	1	20	2013	5	14	1	20	2013	5	14	1	20	-unknown-	57	basic	en	sem-brand	google	omg	Web	Windows Desktop	IE	PT	174
10957	0	4	4	2014	4	4	4	14	2014	4	4	4	14	2014	4	4	4	14	-unknown-	49	basic	en	sem-non-brand	google	omg	Web	Windows Desktop	IE	PT	174
35331	25	2	2	2013	8	7	2	32	2013	8	7	2	32	2013	8	7	2	32	MALE	25	basic	en	direct	direct	untracked	iOS	iPhone	-unknown-	PT	174
13424	0	10	10	2013	9	20	4	38	2013	9	20	4	38	2013	9	20	4	38	MALE	34	basic	en	sem-brand	google	omg	Web	Mac Desktop	Chrome	PT	173
2148	0	0	0	2013	10	3	3	40	2013	10	3	3	40	2013	10	3	3	40	FEMALE	34	facebook	en	direct	direct	tracked-other	Web	Mac Desktop	Safari	PT	172

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block